package com.lq.schoolshop.dao;

import com.lq.schoolshop.pojo.Store;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author
 * @Date2021/1/7 10:24
 * @Version V1.0
 * 店铺接口
 **/
public interface StoreMapper {

    @Select("SELECT * FROM store ORDER BY sort DESC")
    List<Store>selByAll();


    @Select("SELECT * FROM store WHERE id = #{id}")
    List<Store>selById(@Param("id") int id);

}
